{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Weeks","Graphs","Help"],"not_rendered":{"charts":13,"images":8,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Weeks","index":0,"n_rows":60,"n_cols":21,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
["Paycheck Amount",0,null,null,null,null,null,null,null,null,null,"Personal Finance Tracker"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"Monthly Income\"",{"$f":"2*B2","v":0}]
[null,null,null,null,null,{"$f":"IF(cate1=\"\",\"\",cate1)","v":"Rent"},{"$f":"IF(cate2=\"\",\"\",cate2)","v":"Food"},{"$f":"IF(cate3=\"\",\"\",cate3)","v":"Gas"},{"$f":"IF(cate4=\"\",\"\",cate4)","v":""},{"$f":"IF(B12=\"\",\"\",B12)","v":""},{"$f":"IF(B13=\"\",\"\",B13)","v":""},{"$f":"IF(B14=\"\",\"\",B14)","v":""},{"$f":"IF(B15=\"\",\"\",B15)","v":""},{"$f":"IF(B16=\"\",\"\",B16)","v":""},{"$f":"IF(B17=\"\",\"\",B17)","v":""},{"$f":"IF(B18=\"\",\"\",B18)","v":""},{"$f":"IF(B19=\"\",\"\",B19)","v":""},{"$f":"IF(B20=\"\",\"\",B20)","v":""},"Week Total","$ Left for \"Month\"","End of \"Month\" Extra"]
[null,null,null,null,"Week 1",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F5=\"\",\"\",SUM(F5:R5))","v":""},{"$f":"IF(S5=\"\",\"\",$B$2*2-S5)","v":""}]
[null,null,null,null,"Week 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F6=\"\",\"\",SUM(F6:R6))","v":""},{"$f":"IF(S6=\"\",\"\",T5-S6)","v":""}]
[null,"Categories",null,null,"Week 3",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F7=\"\",\"\",SUM(F7:R7))","v":""},{"$f":"IF(S7=\"\",\"\",T6-S7)","v":""}]
[null,"Rent",null,null,"Week 4",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S8=\"\",\"\",T7-S8)","v":""},{"$f":"T8","v":""}]
[null,"Food",null,null,"Week 5",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S9=\"\",\"\",$B$2*2-S9+V8)","v":""}]
[null,"Gas",null,null,"Week 6",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S10=\"\",\"\",T9-S10)","v":""}]
[null,null,null,null,"Week 7",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 8",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S12=\"\",\"\",T11-S12)","v":""},{"$f":"T12","v":""}]
[null,null,null,null,"Week 9",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S13=\"\",\"\",$B$2*2-S13+V12)","v":""}]
[null,null,null,null,"Week 10",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S14=\"\",\"\",T13-S14)","v":""}]
[null,null,null,null,"Week 11",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 12",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T16","v":""}]
[null,null,null,null,"Week 13",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S17=\"\",\"\",$B$2*2-S17+V16)","v":""}]
[null,null,null,null,"Week 14",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S18=\"\",\"\",T17-S18)","v":""}]
[null,null,null,null,"Week 15",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 16",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T20","v":""}]
[null,null,null,null,"Week 17",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S21=\"\",\"\",$B$2*2-S21+V20)","v":""}]
[null,null,null,null,"Week 18",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S22=\"\",\"\",T21-S22)","v":""}]
[null,null,null,null,"Week 19",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 20",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T24","v":""}]
[null,null,null,null,"Week 21",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S25=\"\",\"\",$B$2*2-S25+V24)","v":""}]
[null,null,null,null,"Week 22",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S26=\"\",\"\",T25-S26)","v":""}]
[null,null,null,null,"Week 23",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"Want to be more precise with your savings?",null,null,"Week 24",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T28","v":""}]
[null,"Click here to create savings information and ",null,null,"Week 25",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S29=\"\",\"\",$B$2*2-S29+V28)","v":""}]
[null,"divide it into sub-categories. ",null,null,"Week 26",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S30=\"\",\"\",T29-S30)","v":""}]
[null,"i.e. Future, Emergency, Vacation. . . . .",null,null,"Week 27",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 28",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T32","v":""}]
[null,null,null,null,"Week 29",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S33=\"\",\"\",$B$2*2-S33+V32)","v":""}]
[null,null,null,null,"Week 30",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S34=\"\",\"\",T33-S34)","v":""}]
[null,null,null,null,"Week 31",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 32",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T36","v":""}]
[null,null,null,null,"Week 33",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S37=\"\",\"\",$B$2*2-S37+V36)","v":""}]
[null,null,null,null,"Week 34",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S38=\"\",\"\",T37-S38)","v":""}]
[null,null,null,null,"Week 35",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 36",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T40","v":""}]
[null,null,null,null,"Week 37",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S41=\"\",\"\",$B$2*2-S41+V40)","v":""}]
[null,null,null,null,"Week 38",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S42=\"\",\"\",T41-S42)","v":""}]
[null,null,null,null,"Week 39",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 40",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T44","v":""}]
[null,null,null,null,"Week 41",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S45=\"\",\"\",$B$2*2-S45+V44)","v":""}]
[null,null,null,null,"Week 42",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S46=\"\",\"\",T45-S46)","v":""}]
[null,null,null,null,"Week 43",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 44",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T48","v":""}]
[null,null,null,null,"Week 45",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S49=\"\",\"\",$B$2*2-S49+V48)","v":""}]
[null,null,null,null,"Week 46",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S50=\"\",\"\",T49-S50)","v":""}]
[null,null,null,null,"Week 47",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 48",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T52","v":""}]
[null,null,null,null,"Week 49",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S53=\"\",\"\",$B$2*2-S53+V52)","v":""}]
[null,null,null,null,"Week 50",null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(S54=\"\",\"\",T53-S54)","v":""}]
[null,null,null,null,"Week 51",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Week 52",null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"T56","v":""}]
[null,null,null,null,"Week 53",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Totals",{"$f":"SUM(F5:F57)","v":0},{"$f":"SUM(G5:G57)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F58:R58)","v":0}]
[null,null,null,null,"Averages",{"$f":"IF(F4=\"\",\"\",AVERAGE((F5:F57)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(G4=\"\",\"\",AVERAGE((G5:G57)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"","","","","","","","","","",{"$f":"AVERAGE((S5:S57))","v":{"$error":"#DIV/0!"}},null,"Sheet full? Click here to clear the sheet "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"and to archive completed sheet"]

{"sheet":"Graphs","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Help","index":2,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Joel recently got married and wanted to make an easy way to track him and his wife's expenses and create a budget. In addition to that, we had seen other budget projects for previous semester projects, but they were somewhat limiting. You had to input expenses every day, or didn't have"]
["A choice what your categories were. Things were just cumbersome and complicated, so we wanted to make a somewhat simple finance tracker that was very automated. It would resize things for you, let you make your own categories, sum things up for you, keep you on track with your money"]
["Help you think about the things that you might not think about on your own. All in all, just make keeping track of your money very easy and not this huge hassle."]
[]
["Tutorial button--               Shows the user the main ideas of what each button does"]
[]
["New week button---",null,"This button brings up a userform that shows labels matching the labels you have inputted and hides the unused labels and textboxes."]
[null,null,"It does this by finding out how many categories there are, dimensioning each textbox as a variable using an array. "]
[null,null,"We had to do the array because we never know how many textboxes there will be. We then input the textbox values into next available row in the spreadsheet."]
[null,null,"If the user doesn't put any value into a textbox, we automatically put a zero"]
[null,null,"Then, if the user has set up \"Savings Divisions\" AND has a category titled savings, it brings up a userform for the user to designate how much of the savings they"]
[null,null,"want to allocate to each subdivision they have made."]
[null,null,"Then, it checks to see if there is any money in the \"$ left for month\". It then brings up a userform for the user to designate what they want to do with the extra money"]
[null,null,"or where they want to take the negative money from. They can choose to ignore it, roll it over to next month, or add to/take from their savings."]
[null,null,"If the \"Left for Month\" total falls below $500, it will turn the letter red, alerting the user they are low on money."]
["Delete Week Button---     Simply deletes a week if an error was made or they want to change something"]
[]
["Add Category Button---    This button adds a category to the Categories table which then automatically adds a correspoding label in the main expense table. It limits the number of "]
[null,null,"categories to 13."]
["Delete Category Button-- This will delete one of the categories in the category table and shift the categories below it up so there isn't a blank spot in the middle."]
[null,null,"We have set up the expenses table so the labels on the top simply reflect whatever is in the categories table. So if a category is deleted and the lower ones shift up"]
[null,null,"then the corresponding label in the expenses table is deleted and the others shift over. The only problem was that all the expenses that were inputted with that "]
[null,null,"category wouldn't shift as well so we would end up with this situation"]
[null,null,null,null,"before",null,null,null,"after"]
[null,null,null,"bills","rent","gas",null,"bills","gas"]
[null,null,null,10,1,2,null,10,1,2]
[null,null,null,9,1,2,null,9,1,2]
[null,null,null,8,1,2,null,8,1,2]
[null,null,"So we had to make this button also clear all the values under the deleted label and then shift all the other columns of expenses over so they were under the correct"]
[null,null,"label. (*See \"future work\" for the problem this creates)"]
["Set up Savings Button--    This button allows the user to set up savings allocations and watch their savings grow. (hopefully) It brings up a userform which asks them if they currently have"]
[null,null,"money in a savings account, has them input how much and then indicate how many ways to allocate their savings (1-4 divisions). They enter the labels they want for"]
[null,null,"each division and then indicate what percentage of the total amount they currently have to input into each division. The percentages have to add up to 100% or it"]
[null,null,"will have them try again. Upon submitting, a small formatted table appears with there desired divisions with the percentages they indicated. Now, when they input"]
[null,null,"expenses for a new  week, and they have a savings category, they can also designate how much of what they put in to allocate to each of their new divisions."]
["Sheet Functions","At the bottom of the whole sheet it shows the averages for each category so you can get an idea of how much you spend on average each week."]
[null,"We had an issue with taking an average of the totals because the formula we originally put in would just add up the cells to the left of it which creates this"]
[null,null,null,null,null,null,null,null,null,"total"]
[null,null,"week 1",3,3,3,3,3,3,{"$f":"SUM(D39:I39)","v":18}]
[null,null,"week 2",1,1,1,1,1,1,6]
[null,null,"week 3",null,null,null,null,null,null,{"$f":"SUM(D41:I41)","v":0}]
[null,null,"week 4",null,null,null,null,null,null,{"$f":"SUM(D42:I42)","v":0}]
[null,null,null,null,null,null,null,null,"average",{"$f":"AVERAGE(J39:J42)","v":6}]
[null,"When in reality, we have only had 2 weeks of expenses so the average would be 12, not 6. So we had to write a funtion that said if food cateogory for the week is BLANK"]
[null,"then it will make the total blank, not 0. This works because if they have inputed trasactions for the week, something will show up in the food category (# or -)"]
["New Sheet Button","This button allows the user to clear the sheet of all transactions to start a new year and have the option to archive the current trasaction record into a new sheet in the workbook."]
[]
["Change Paycheck Amount Button",null,"This button allows you to change the paycheck amount. "]
[]
["FUTURE WORK","We Realize that there are many holes in the project, but given more time we would be able to fill them. Some future work may include"]
[null,"#Adding a \"Subtract From Savings\" Button so that if they spend some money from savings they can adjust those numbers."]
[null,"#Having a negative amount at the end of the month. Creating a userform similar to the \"extra money\" userform that if they are in the negative, they can designate where they want to money to come from."]
[null,"#Only allowing the user to input numerical values into certain text boxes. In many of the boxes, letters will cause the code to crash."]
[null,"#For the archiving button, if there has already been a sheet archived with \"2015\", it won't allow you to make another. Currently, if you archive 2 sheets and designate the year as 2015 for both, it crashes."]
["*","#Although we made the delete category button able to clear the values beneath the deleted category, this messes up all the totals. i.e."]
[null,"If I delete one category after for weeks, I would want to leave those totals in those previous 4 weeks, but because the total columns are just a sum function it does this…"]
[null,null,"bills","rent","gas","Total","Left for month",null,null,"bills","gas","Total","Left for month"]
[null,null,10,1,2,{"$f":"SUM(C58:E58)","v":13},200,null,null,10,2,{"$f":"SUM(I58:K58)","v":12},200]
[null,null,9,1,2,{"$f":"SUM(C59:E59)","v":12},{"$f":"G58-F59","v":188},null,null,9,2,{"$f":"SUM(I59:K59)","v":11},{"$f":"M58-L59","v":189}]
[null,null,8,1,2,11,{"$f":"G59-F60","v":177},null,null,8,2,10,{"$f":"M59-L60","v":179}]
[null,null,8,1,2,11,166,null,null,8,2,10,169]
[null,"This messes up the total and \"left for the month\""]
[null,"#If you use the delete week button on a week that ended with \"extra\" and you allocated that extra to your savings, if you then go and delete that week, it doesn't subtract those amounts from savings."]